<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %><%--
  Created by IntelliJ IDEA.
  User: 你
  Date: 2020/10/21
  Time: 8:28
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>编辑页面</title>
    <link rel="stylesheet" href="../css/bootstrap.css">

    <script src="../js/jquery.min.js"></script>
    <script src="../js/bootstrap.js"></script>
    <script src="../js/bootstrap.bundle.js"></script>

    <style>
        .container{
            width: 50%;
            margin-top: 20px;
        }
</head>
<body>
<div class="container">
            <div class="row clearfix">
                <div class="col-md-12 column">
                   <h3 style="text-align:center">编辑页面</h3>
                   <form method="post" action="update.jsp">




  <%
    int id=Integer.parseInt(request.getParameter("id"));

    Class.forName(("com.mysql.jdbc.Driver"));
    String url="jdbc:mysql://localhost:3306/book";
    Connection connection= DriverManager.getConnection(url,"root","root");

    String sql="select * from user where id=?";
    PreparedStatement ps =connection.prepareStatement(sql);
    ps.setInt(1,id);
    ResultSet rs = ps.executeQuery()
    while(rs.next()){

            out.print("<input type='hidden' name='id' value="+rs.getString("id")+">");
            out.print("用户名：<input type='text',name='username value=" + rs.getString("username") + "><br>");
            out.print("用户名：<input type='text',name='password'  value=" + rs.getString("password") + "><br>");
            out.print("用户名：<input type='text',name='gender'  value=" + rs.getString("gender") + "><br>");
            out.print("用户名：<input type='text',name='age'  value=" + rs.getString("age") + "><br>");

}
%>
            <button type="submit" style="width=100%" class="btn btn-info">提交</button>
        </form>
        </div>
        </div>
        </div>
</body>
</html>
}